SUPPORT / SAMPLES & SAS NOTES
Problem Note 68061: Google BigQuery numeric variables might be displayed as garbage
 |  |  |  |
The environment variable SAS_BIGQUERY_DEFAULT_NUMERIC_FORMAT does not recognize when an invalid character format is specified. Rather than returning an error that indicates that the format is not valid, the numeric data in a BigQuery table might be displayed as garbage, as shown below:
To ensure that invalid formats are recognized, use the data set option DEFAULT_NUMERIC_FORMAT.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.4 | 9.4 | 9.4 TS1M6 | 9.4 TS1M8 |
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.04 | 2021.1.2 | Viya | Viya |